Airbnb Profiling Report

Dataset statistics

Number of variables	16
Number of observations	1073
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	134.3 KiB
Average record size in memory	128.1 B

Variable types

Numeric	10
Text	3
Categorical	2
DateTime	1

Alerts

`disponibilidade` has constant value ""	Constant
`latitude` is highly overall correlated with `longitude` and 1 other fields	High correlation
`longitude` is highly overall correlated with `latitude`	High correlation
`numero_reviews` is highly overall correlated with `reviews_por_mes`	High correlation
`preco` is highly overall correlated with `latitude`	High correlation
`reviews_por_mes` is highly overall correlated with `numero_reviews` and 1 other fields	High correlation
`reviewss_ultimo_mes` is highly overall correlated with `reviews_por_mes`	High correlation
`tipo` is highly imbalanced (58.1%)	Imbalance
`id_imovel` has unique values	Unique
`reviewss_ultimo_mes` has 566 (52.7%) zeros	Zeros

Reproduction

Analysis started	2024-04-29 20:56:49.939460
Analysis finished	2024-04-29 20:57:36.247080
Duration	46.31 seconds
Software version	ydata-profiling vv4.7.0
Download configuration	config.json

id_imovel
Real number (ℝ)

UNIQUE

Distinct	1073
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.4662791 × 10¹⁷

Minimum	77318
Maximum	1.0515477 × 10¹⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.5 KiB

Quantile statistics

Minimum	77318
5-th percentile	3020086.2
Q1	17330197
median	41902371
Q3	6.8857447 × 10¹⁷
95-th percentile	8.8781867 × 10¹⁷
Maximum	1.0515477 × 10¹⁸
Range	1.0515477 × 10¹⁸
Interquartile range (IQR)	6.8857447 × 10¹⁷

Descriptive statistics

Standard deviation	3.6443176 × 10¹⁷
Coefficient of variation (CV)	1.4776582
Kurtosis	-1.1355567
Mean	2.4662791 × 10¹⁷
Median Absolute Deviation (MAD)	28196170
Skewness	0.86074818
Sum	6.3773328 × 10¹⁸
Variance	1.328105 × 10³⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13926723	1	0.1%
2440469	1	0.1%
9.071010474 × 10¹⁷	1	0.1%
9.096305877 × 10¹⁷	1	0.1%
9.179795333 × 10¹⁷	1	0.1%
9.204612128 × 10¹⁷	1	0.1%
9.240376626 × 10¹⁷	1	0.1%
9.237521833 × 10¹⁷	1	0.1%
9.280409295 × 10¹⁷	1	0.1%
9.259353979 × 10¹⁷	1	0.1%
Other values (1063)	1063	99.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
77318	1	0.1%
295955	1	0.1%
330913	1	0.1%
435728	1	0.1%
462947	1	0.1%
483578	1	0.1%
573086	1	0.1%
670109	1	0.1%
681179	1	0.1%
710338	1	0.1%

Value	Count	Frequency (%)
1.051547688 × 10¹⁸	1	0.1%
1.022389363 × 10¹⁸	1	0.1%
1.020530394 × 10¹⁸	1	0.1%
1.016576333 × 10¹⁸	1	0.1%
1.010905172 × 10¹⁸	1	0.1%
1.009889631 × 10¹⁸	1	0.1%
1.003697341 × 10¹⁸	1	0.1%
9.987896482 × 10¹⁷	1	0.1%
9.986964432 × 10¹⁷	1	0.1%
9.963775646 × 10¹⁷	1	0.1%

nome
Text

Distinct	814
Distinct (%)	75.9%
Missing	0
Missing (%)	0.0%
Memory size	8.5 KiB

Length

Max length	92
Median length	83
Mean length	67.55918
Min length	45

Characters and Unicode

Total characters	72491
Distinct characters	75
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	728 ?
Unique (%)	67.8%

Sample

1st row	Home in Rio de Janeiro · 5.0 · 1 quarto · 1 cama · 1 banheiro
2nd row	Cabin in Gávea · 4.0 · 1 quarto · 1 cama · 2 banheiros
3rd row	Condo in Recreio dos Bandeirantes · 1 quarto · 3 camas · 1 banheiro
4th row	Rental unit in Rio de Janeiro · 1 quarto · 1 cama · 1 banheiro compartilhado
5th row	Rental unit in Rio de Janeiro · 2 quartos · 3 camas · 1 banheiro

Value	Count	Frequency (%)
·	3930	23.6%
1	1694	10.2%
in	1073	6.4%
rental	824	4.9%
unit	824	4.9%
2	821	4.9%
banheiro	688	4.1%
camas	635	3.8%
quarto	613	3.7%
rio	609	3.7%
Other values (187)	4965	29.8%

Most occurring characters

Value	Count	Frequency (%)
	15617	21.5%
a	7256	10.0%
n	4854	6.7%
i	4647	6.4%
o	4296	5.9%
·	3930	5.4%
e	3665	5.1%
r	3232	4.5%
t	3189	4.4%
u	1998	2.8%
Other values (65)	19807	27.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	72491	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	15617	21.5%
a	7256	10.0%
n	4854	6.7%
i	4647	6.4%
o	4296	5.9%
·	3930	5.4%
e	3665	5.1%
r	3232	4.5%
t	3189	4.4%
u	1998	2.8%
Other values (65)	19807	27.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	72491	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	15617	21.5%
a	7256	10.0%
n	4854	6.7%
i	4647	6.4%
o	4296	5.9%
·	3930	5.4%
e	3665	5.1%
r	3232	4.5%
t	3189	4.4%
u	1998	2.8%
Other values (65)	19807	27.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	72491	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	15617	21.5%
a	7256	10.0%
n	4854	6.7%
i	4647	6.4%
o	4296	5.9%
·	3930	5.4%
e	3665	5.1%
r	3232	4.5%
t	3189	4.4%
u	1998	2.8%
Other values (65)	19807	27.3%

host_id
Real number (ℝ)

Distinct	954
Distinct (%)	88.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.3702023 × 10⁸

Minimum	11739
Maximum	5.4505559 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.5 KiB

Quantile statistics

Minimum	11739
5-th percentile	3678983.6
Q1	22713969
median	74337848
Q3	2.2746344 × 10⁸
95-th percentile	4.542476 × 10⁸
Maximum	5.4505559 × 10⁸
Range	5.4504385 × 10⁸
Interquartile range (IQR)	2.0474947 × 10⁸

Descriptive statistics

Standard deviation	1.4474169 × 10⁸
Coefficient of variation (CV)	1.0563526
Kurtosis	-0.043378689
Mean	1.3702023 × 10⁸
Median Absolute Deviation (MAD)	62823987
Skewness	1.0847596
Sum	1.4702271 × 10¹¹
Variance	2.0950156 × 10¹⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
292590334	17	1.6%
315740743	9	0.8%
22713969	5	0.5%
172482654	4	0.4%
271367467	4	0.4%
27229964	3	0.3%
58474569	3	0.3%
6000862	3	0.3%
15925374	3	0.3%
316737705	3	0.3%
Other values (944)	1019	95.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
11739	2	0.2%
110002	1	0.1%
153721	1	0.1%
198706	1	0.1%
403781	1	0.1%
453307	1	0.1%
500892	1	0.1%
533666	1	0.1%
652180	1	0.1%
690247	1	0.1%

Value	Count	Frequency (%)
545055587	1	0.1%
519053877	2	0.2%
513697681	1	0.1%
510549225	1	0.1%
509479873	1	0.1%
505338658	1	0.1%
502278654	1	0.1%
500818847	1	0.1%
500459166	1	0.1%
497921624	1	0.1%

host_nome
Text

Distinct	590
Distinct (%)	55.0%
Missing	0
Missing (%)	0.0%
Memory size	8.5 KiB

Length

Max length	31
Median length	27
Mean length	7.1817335
Min length	2

Characters and Unicode

Total characters	7706
Distinct characters	67
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	407 ?
Unique (%)	37.9%

Sample

1st row	Glauco
2nd row	Amanda
3rd row	Gizella
4th row	Thiago
5th row	Liliane Marques

Value	Count	Frequency (%)
maria	29	2.3%
ana	27	2.1%
belsito	17	1.4%
apartments	17	1.4%
marcelo	16	1.3%
luiz	14	1.1%
pedro	11	0.9%
carolina	10	0.8%
paula	10	0.8%
claudio	9	0.7%
Other values (572)	1096	87.3%

Most occurring characters

Value	Count	Frequency (%)
a	1215	15.8%
i	726	9.4%
e	606	7.9%
n	540	7.0%
r	530	6.9%
l	486	6.3%
o	477	6.2%
s	268	3.5%
u	225	2.9%
t	195	2.5%
Other values (57)	2438	31.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	7706	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	1215	15.8%
i	726	9.4%
e	606	7.9%
n	540	7.0%
r	530	6.9%
l	486	6.3%
o	477	6.2%
s	268	3.5%
u	225	2.9%
t	195	2.5%
Other values (57)	2438	31.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	7706	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	1215	15.8%
i	726	9.4%
e	606	7.9%
n	540	7.0%
r	530	6.9%
l	486	6.3%
o	477	6.2%
s	268	3.5%
u	225	2.9%
t	195	2.5%
Other values (57)	2438	31.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	7706	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	1215	15.8%
i	726	9.4%
e	606	7.9%
n	540	7.0%
r	530	6.9%
l	486	6.3%
o	477	6.2%
s	268	3.5%
u	225	2.9%
t	195	2.5%
Other values (57)	2438	31.6%

bairro
Text

Distinct	61
Distinct (%)	5.7%
Missing	0
Missing (%)	0.0%
Memory size	8.5 KiB

Length

Max length	24
Median length	20
Mean length	10.200373
Min length	4

Characters and Unicode

Total characters	10945
Distinct characters	53
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	22 ?
Unique (%)	2.1%

Sample

1st row	Humaitá
2nd row	Gávea
3rd row	Recreio dos Bandeirantes
4th row	Rio Comprido
5th row	Jacarepaguá

Value	Count	Frequency (%)
copacabana	341	23.0%
tijuca	113	7.6%
barra	108	7.3%
da	107	7.2%
ipanema	79	5.3%
botafogo	59	4.0%
jacarepaguá	59	4.0%
leblon	53	3.6%
recreio	48	3.2%
dos	48	3.2%
Other values (72)	469	31.6%

Most occurring characters

Value	Count	Frequency (%)
a	2742	25.1%
o	834	7.6%
n	749	6.8%
e	687	6.3%
r	599	5.5%
c	594	5.4%
p	481	4.4%
C	429	3.9%
b	411	3.8%
	411	3.8%
Other values (43)	3008	27.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	10945	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	2742	25.1%
o	834	7.6%
n	749	6.8%
e	687	6.3%
r	599	5.5%
c	594	5.4%
p	481	4.4%
C	429	3.9%
b	411	3.8%
	411	3.8%
Other values (43)	3008	27.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	10945	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	2742	25.1%
o	834	7.6%
n	749	6.8%
e	687	6.3%
r	599	5.5%
c	594	5.4%
p	481	4.4%
C	429	3.9%
b	411	3.8%
	411	3.8%
Other values (43)	3008	27.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	10945	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	2742	25.1%
o	834	7.6%
n	749	6.8%
e	687	6.3%
r	599	5.5%
c	594	5.4%
p	481	4.4%
C	429	3.9%
b	411	3.8%
	411	3.8%
Other values (43)	3008	27.5%

latitude
Real number (ℝ)

HIGH CORRELATION

Distinct	1013
Distinct (%)	94.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-22.965852

Minimum	-23.064618
Maximum	-22.74969
Zeros	0
Zeros (%)	0.0%
Negative	1073
Negative (%)	100.0%
Memory size	8.5 KiB

Quantile statistics

Minimum	-23.064618
5-th percentile	-23.012142
Q1	-22.98359
median	-22.96975
Q3	-22.95148
95-th percentile	-22.91271
Maximum	-22.74969
Range	0.314928
Interquartile range (IQR)	0.03211

Descriptive statistics

Standard deviation	0.033020379
Coefficient of variation (CV)	-0.0014378034
Kurtosis	4.7990202
Mean	-22.965852
Median Absolute Deviation (MAD)	0.014619
Skewness	1.2074981
Sum	-24642.359
Variance	0.0010903455
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-22.97716	4	0.4%
-22.96471	4	0.4%
-22.962423	3	0.3%
-22.96941	3	0.3%
-22.97358	3	0.3%
-22.9831	3	0.3%
-22.99804	3	0.3%
-22.9689	3	0.3%
-22.97909	2	0.2%
-22.96411	2	0.2%
Other values (1003)	1043	97.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-23.064618	1	0.1%
-23.06415	1	0.1%
-23.05091	1	0.1%
-23.03599	1	0.1%
-23.031011	1	0.1%
-23.03092	1	0.1%
-23.03005	1	0.1%
-23.03002	1	0.1%
-23.02971	1	0.1%
-23.02831	1	0.1%

Value	Count	Frequency (%)
-22.74969	1	0.1%
-22.75295	1	0.1%
-22.805221	1	0.1%
-22.806724	1	0.1%
-22.81064	1	0.1%
-22.8118	1	0.1%
-22.8179	1	0.1%
-22.84107	1	0.1%
-22.86509	1	0.1%
-22.877013	1	0.1%

longitude
Real number (ℝ)

HIGH CORRELATION

Distinct	1010
Distinct (%)	94.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-43.23803

Minimum	-43.690056
Maximum	-43.10605
Zeros	0
Zeros (%)	0.0%
Negative	1073
Negative (%)	100.0%
Memory size	8.5 KiB

Quantile statistics

Minimum	-43.690056
5-th percentile	-43.443278
Q1	-43.23766
median	-43.1919
Q3	-43.18325
95-th percentile	-43.174356
Maximum	-43.10605
Range	0.584006
Interquartile range (IQR)	0.05441

Descriptive statistics

Standard deviation	0.089877896
Coefficient of variation (CV)	-0.0020786769
Kurtosis	1.5970671
Mean	-43.23803
Median Absolute Deviation (MAD)	0.01349
Skewness	-1.6087941
Sum	-46394.407
Variance	0.0080780362
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-43.19046	4	0.4%
-43.17932	3	0.3%
-43.192	3	0.3%
-43.188864	3	0.3%
-43.19107	3	0.3%
-43.175888	3	0.3%
-43.256821	3	0.3%
-43.19054	2	0.2%
-43.18346	2	0.2%
-43.18214	2	0.2%
Other values (1000)	1045	97.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-43.690056	1	0.1%
-43.566976	1	0.1%
-43.56487	1	0.1%
-43.55281	1	0.1%
-43.55113	1	0.1%
-43.54527	1	0.1%
-43.51179	1	0.1%
-43.49576	1	0.1%
-43.49481	1	0.1%
-43.49304	1	0.1%

Value	Count	Frequency (%)
-43.10605	1	0.1%
-43.10803	1	0.1%
-43.16123	1	0.1%
-43.161297	1	0.1%
-43.1616	1	0.1%
-43.16282	1	0.1%
-43.16396	1	0.1%
-43.16641	1	0.1%
-43.16762	1	0.1%
-43.167629	1	0.1%

tipo
Categorical

IMBALANCE

Distinct	4
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	8.5 KiB

casa/apartamento	825
quarto privado	239
quarto compartilhado	7
quarto de hotel	2

Length

Max length	20
Median length	16
Mean length	15.578751
Min length	14

Characters and Unicode

Total characters	16716
Distinct characters	19
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	casa/apartamento
2nd row	casa/apartamento
3rd row	casa/apartamento
4th row	quarto privado
5th row	casa/apartamento

Common Values

Value	Count	Frequency (%)
casa/apartamento	825	76.9%
quarto privado	239	22.3%
quarto compartilhado	7	0.7%
quarto de hotel	2	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
casa/apartamento	825	62.4%
quarto	248	18.7%
privado	239	18.1%
compartilhado	7	0.5%
de	2	0.2%
hotel	2	0.2%

Most occurring characters

Value	Count	Frequency (%)
a	4626	27.7%
t	1907	11.4%
o	1328	7.9%
r	1319	7.9%
p	1071	6.4%
c	832	5.0%
m	832	5.0%
e	829	5.0%
n	825	4.9%
/	825	4.9%
Other values (9)	2322	13.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	16716	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	4626	27.7%
t	1907	11.4%
o	1328	7.9%
r	1319	7.9%
p	1071	6.4%
c	832	5.0%
m	832	5.0%
e	829	5.0%
n	825	4.9%
/	825	4.9%
Other values (9)	2322	13.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	16716	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	4626	27.7%
t	1907	11.4%
o	1328	7.9%
r	1319	7.9%
p	1071	6.4%
c	832	5.0%
m	832	5.0%
e	829	5.0%
n	825	4.9%
/	825	4.9%
Other values (9)	2322	13.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	16716	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	4626	27.7%
t	1907	11.4%
o	1328	7.9%
r	1319	7.9%
p	1071	6.4%
c	832	5.0%
m	832	5.0%
e	829	5.0%
n	825	4.9%
/	825	4.9%
Other values (9)	2322	13.9%

preco
Real number (ℝ)

HIGH CORRELATION

Distinct	61
Distinct (%)	5.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1167.7542

Minimum	142.4
Maximum	8674.7792
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.5 KiB

Quantile statistics

Minimum	142.4
5-th percentile	549.53689
Q1	785.29567
median	1311.7262
Q3	1311.7262
95-th percentile	1726.5436
Maximum	8674.7792
Range	8532.3792
Interquartile range (IQR)	526.43056

Descriptive statistics

Standard deviation	629.54468
Coefficient of variation (CV)	0.53910717
Kurtosis	90.266377
Mean	1167.7542
Median Absolute Deviation (MAD)	252.12293
Skewness	7.7436578
Sum	1253000.3
Variance	396326.51
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1311.726228	341	31.8%
1350.845188	103	9.6%
1726.543616	79	7.4%
768.3704453	59	5.5%
785.2956685	57	5.3%
1547.793061	53	4.9%
962.8882455	48	4.5%
549.5368889	38	3.5%
748.8612132	36	3.4%
678.5729443	32	3.0%
Other values (51)	227	21.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
142.4	1	0.1%
158.6153846	1	0.1%
245	1	0.1%
268.7083333	2	0.2%
271.8333333	2	0.2%
298.4444444	4	0.4%
318.03125	1	0.1%
357.6724138	4	0.4%
368.1111111	1	0.1%
371	1	0.1%

Value	Count	Frequency (%)
8674.779221	4	0.4%
8478.032787	1	0.1%
2487.029326	6	0.6%
1938.118012	2	0.2%
1770	1	0.1%
1726.543616	79	7.4%
1567.038911	9	0.8%
1547.793061	53	4.9%
1350.845188	103	9.6%
1337.539171	7	0.7%

noites_minimas
Real number (ℝ)

Distinct	23
Distinct (%)	2.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.904778

Minimum	1
Maximum	365
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.5 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	3
Q3	4
95-th percentile	15
Maximum	365
Range	364
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	16.782862
Coefficient of variation (CV)	3.4217374
Kurtosis	304.03637
Mean	4.904778
Median Absolute Deviation (MAD)	1
Skewness	16.147924
Sum	5262.8268
Variance	281.66446
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=23)

Value	Count	Frequency (%)
2	333	31.0%
3	246	22.9%
1	189	17.6%
4	97	9.0%
5	92	8.6%
7	27	2.5%
30	19	1.8%
6	18	1.7%
28	12	1.1%
10	11	1.0%
Other values (13)	29	2.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	189	17.6%
2	333	31.0%
3	246	22.9%
4	97	9.0%
4.826785714	1	0.1%
5	92	8.6%
6	18	1.7%
7	27	2.5%
8	2	0.2%
10	11	1.0%

Value	Count	Frequency (%)
365	1	0.1%
300	1	0.1%
200	1	0.1%
90	1	0.1%
88	1	0.1%
60	1	0.1%
30	19	1.8%
28	12	1.1%
27	1	0.1%
25	4	0.4%

numero_reviews
Real number (ℝ)

HIGH CORRELATION

Distinct	100
Distinct (%)	9.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13.67288

Minimum	1
Maximum	355
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.5 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	12
95-th percentile	61.4
Maximum	355
Range	354
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	27.839763
Coefficient of variation (CV)	2.0361302
Kurtosis	38.49873
Mean	13.67288
Median Absolute Deviation (MAD)	3
Skewness	5.1625578
Sum	14671
Variance	775.05241
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	215	20.0%
2	149	13.9%
3	109	10.2%
4	77	7.2%
5	56	5.2%
6	52	4.8%
7	34	3.2%
8	34	3.2%
9	29	2.7%
14	21	2.0%
Other values (90)	297	27.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	215	20.0%
2	149	13.9%
3	109	10.2%
4	77	7.2%
5	56	5.2%
6	52	4.8%
7	34	3.2%
8	34	3.2%
9	29	2.7%
10	20	1.9%

Value	Count	Frequency (%)
355	1	0.1%
252	1	0.1%
238	1	0.1%
222	1	0.1%
189	1	0.1%
169	1	0.1%
168	1	0.1%
156	1	0.1%
135	2	0.2%
133	1	0.1%

ultima_review
Date

Distinct	512
Distinct (%)	47.7%
Missing	0
Missing (%)	0.0%
Memory size	8.5 KiB

Minimum	2013-07-21 00:00:00
Maximum	2023-12-23 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

reviews_por_mes
Real number (ℝ)

HIGH CORRELATION

Distinct	171
Distinct (%)	15.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.37944082

Minimum	0.01
Maximum	7.11
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.5 KiB

Quantile statistics

Minimum	0.01
5-th percentile	0.02
Q1	0.07
median	0.16
Q3	0.43
95-th percentile	1.48
Maximum	7.11
Range	7.1
Interquartile range (IQR)	0.36

Descriptive statistics

Standard deviation	0.56573874
Coefficient of variation (CV)	1.4909802
Kurtosis	24.482347
Mean	0.37944082
Median Absolute Deviation (MAD)	0.12
Skewness	3.7140433
Sum	407.14
Variance	0.32006032
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.1	69	6.4%
0.04	68	6.3%
0.02	57	5.3%
0.08	54	5.0%
0.06	52	4.8%
0.03	41	3.8%
0.13	37	3.4%
0.17	34	3.2%
0.09	32	3.0%
0.19	31	2.9%
Other values (161)	598	55.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.01	16	1.5%
0.02	57	5.3%
0.03	41	3.8%
0.04	68	6.3%
0.05	19	1.8%
0.06	52	4.8%
0.07	20	1.9%
0.08	54	5.0%
0.09	32	3.0%
0.1	69	6.4%

Value	Count	Frequency (%)
7.11	1	0.1%
3.62	1	0.1%
3.4	1	0.1%
3.35	1	0.1%
3.21	1	0.1%
3.16	1	0.1%
3.06	1	0.1%
3.01	1	0.1%
2.96	1	0.1%
2.91	1	0.1%

hosts_qtd
Real number (ℝ)

Distinct	32
Distinct (%)	3.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.5750233

Minimum	1
Maximum	185
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.5 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	20
Maximum	185
Range	184
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	14.453354
Coefficient of variation (CV)	3.159187
Kurtosis	91.820289
Mean	4.5750233
Median Absolute Deviation (MAD)	0
Skewness	8.6436296
Sum	4909
Variance	208.89945
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=32)

Value	Count	Frequency (%)
1	659	61.4%
2	186	17.3%
3	53	4.9%
4	35	3.3%
41	18	1.7%
5	13	1.2%
9	11	1.0%
6	10	0.9%
22	10	0.9%
7	9	0.8%
Other values (22)	69	6.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	659	61.4%
2	186	17.3%
3	53	4.9%
4	35	3.3%
5	13	1.2%
6	10	0.9%
7	9	0.8%
8	5	0.5%
9	11	1.0%
10	7	0.7%

Value	Count	Frequency (%)
185	3	0.3%
145	2	0.2%
142	1	0.1%
80	1	0.1%
56	2	0.2%
47	2	0.2%
41	18	1.7%
38	5	0.5%
35	3	0.3%
33	2	0.2%

disponibilidade
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.5 KiB

0	1073

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1073
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	1073	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	1073	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	1073	100.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1073	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	1073	100.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1073	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	1073	100.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1073	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	1073	100.0%

reviewss_ultimo_mes
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	38
Distinct (%)	3.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.5163094

Minimum	0
Maximum	53
Zeros	566
Zeros (%)	52.7%
Negative	0
Negative (%)	0.0%
Memory size	8.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	2
95-th percentile	13
Maximum	53
Range	53
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	5.6315645
Coefficient of variation (CV)	2.2380255
Kurtosis	24.060137
Mean	2.5163094
Median Absolute Deviation (MAD)	0
Skewness	4.2852281
Sum	2700
Variance	31.714519
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=38)

Value	Count	Frequency (%)
0	566	52.7%
1	170	15.8%
2	83	7.7%
3	52	4.8%
4	29	2.7%
6	28	2.6%
5	27	2.5%
7	16	1.5%
8	14	1.3%
9	11	1.0%
Other values (28)	77	7.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	566	52.7%
1	170	15.8%
2	83	7.7%
3	52	4.8%
4	29	2.7%
5	27	2.5%
6	28	2.6%
7	16	1.5%
8	14	1.3%
9	11	1.0%

Value	Count	Frequency (%)
53	1	0.1%
49	1	0.1%
47	1	0.1%
45	1	0.1%
42	1	0.1%
33	2	0.2%
32	1	0.1%
31	1	0.1%
29	1	0.1%
28	2	0.2%

Auto

Heatmap
Table

	host_id	hosts_qtd	id_imovel	latitude	longitude	noites_minimas	numero_reviews	preco	reviews_por_mes	reviewss_ultimo_mes	tipo
host_id	1.000	-0.011	0.455	-0.046	-0.062	-0.150	-0.074	-0.068	0.166	0.201	0.000
hosts_qtd	-0.011	1.000	0.167	-0.085	-0.030	0.044	-0.052	0.122	0.071	0.121	0.000
id_imovel	0.455	0.167	1.000	-0.032	-0.015	-0.194	-0.305	-0.003	0.325	0.451	0.022
latitude	-0.046	-0.085	-0.032	1.000	0.601	-0.012	-0.001	-0.709	-0.019	-0.019	0.097
longitude	-0.062	-0.030	-0.015	0.601	1.000	0.135	0.104	-0.248	0.086	0.089	0.058
noites_minimas	-0.150	0.044	-0.194	-0.012	0.135	1.000	-0.005	0.125	-0.129	-0.136	0.000
numero_reviews	-0.074	-0.052	-0.305	-0.001	0.104	-0.005	1.000	0.047	0.715	0.288	0.000
preco	-0.068	0.122	-0.003	-0.709	-0.248	0.125	0.047	1.000	0.057	0.065	0.076
reviews_por_mes	0.166	0.071	0.325	-0.019	0.086	-0.129	0.715	0.057	1.000	0.637	0.000
reviewss_ultimo_mes	0.201	0.121	0.451	-0.019	0.089	-0.136	0.288	0.065	0.637	1.000	0.000
tipo	0.000	0.000	0.022	0.097	0.058	0.000	0.000	0.076	0.000	0.000	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	id_imovel	nome	host_id	host_nome	bairro	latitude	longitude	tipo	preco	noites_minimas	numero_reviews	ultima_review	reviews_por_mes	hosts_qtd	reviewss_ultimo_mes
0	13926723	Home in Rio de Janeiro · 5.0 · 1 quarto · 1 cama · 1 banheiro	21482982	Glauco	Humaitá	-22.952720	-43.198410	casa/apartamento	795.204301	27.0	13	2023-08-10	0.14	3	1
1	564919861942861050	Cabin in Gávea · 4.0 · 1 quarto · 1 cama · 2 banheiros	363844454	Amanda	Gávea	-22.980390	-43.241180	casa/apartamento	1337.539171	1.0	4	2023-04-23	0.18	1	3
2	4250213	Condo in Recreio dos Bandeirantes · 1 quarto · 3 camas · 1 banheiro	16203836	Gizella	Recreio dos Bandeirantes	-23.030920	-43.474190	casa/apartamento	962.888246	3.0	2	2022-11-15	0.13	1	0
3	4854025	Rental unit in Rio de Janeiro · 1 quarto · 1 cama · 1 banheiro compartilhado	24971450	Thiago	Rio Comprido	-22.925016	-43.201073	quarto privado	553.366972	2.0	1	2021-07-30	0.03	1	0
4	5083946	Rental unit in Rio de Janeiro · 2 quartos · 3 camas · 1 banheiro	26259326	Liliane Marques	Jacarepaguá	-22.969410	-43.397750	casa/apartamento	785.295669	4.0	1	2019-09-30	0.02	1	0
5	5278558	Cottage in Rio de Janeiro · 3 quartos · 13 camas · 3.5 banheiros	9819895	João Pedro	Vargem Grande	-22.970870	-43.494810	casa/apartamento	932.823529	1.0	2	2019-12-29	0.03	4	0
6	5820997	Rental unit in Rio de Janeiro · 1 quarto · 1 cama · 1 banheiro	30210745	Maurício E Natália	Grajaú	-22.920072	-43.269055	casa/apartamento	374.211538	3.0	2	2023-02-21	0.17	1	2
7	6039756	Condo in Rio de Janeiro · 1 quarto · 1 cama · 1 private banheiro	5014163	Anderson	Barra da Tijuca	-23.009060	-43.322700	quarto privado	1350.845188	2.0	2	2017-09-24	0.02	2	0
8	7272073	Rental unit in Rio de Janeiro · Studio · 3 camas · 1 banheiro	38074964	Rogerio	Flamengo	-22.939090	-43.174490	casa/apartamento	678.572944	3.0	1	2016-02-11	0.01	1	0
9	7323556	Rental unit in Rio de Janeiro · 2 quartos · 3 camas · 1 banheiro	38364611	Maria	Copacabana	-22.977120	-43.188550	casa/apartamento	1311.726228	3.0	2	2016-01-05	0.02	4	0

	id_imovel	nome	host_id	host_nome	bairro	latitude	longitude	tipo	preco	noites_minimas	numero_reviews	ultima_review	reviews_por_mes	hosts_qtd	reviewss_ultimo_mes
1063	969793423437579937	Rental unit in Rio de Janeiro · 5.0 · 1 quarto · 1 cama · 2 banheiros	92415018	Elaine	Barra da Tijuca	-23.011537	-43.306968	casa/apartamento	1350.845188	2.0	3	2023-12-14	1.61	1	3
1064	980317076344793068	Rental unit in Rio de Janeiro · 5.0 · 1 quarto · 4 camas · 1 banheiro	154114238	Breno	Recreio dos Bandeirantes	-23.031011	-43.475893	casa/apartamento	962.888246	2.0	23	2023-12-23	7.11	4	23
1065	998696443198877884	Rental unit in Rio de Janeiro · 5.0 · 1 quarto · 6 camas · 2 banheiro compartilhados	164177980	Flávia	Méier	-22.900972	-43.275702	quarto compartilhado	298.444444	1.0	3	2023-11-20	1.70	18	3
1066	996377564577497393	Aparthotel in Rio de Janeiro · 5.0 · 2 quartos · 2 camas · 1 banheiro	13323106	Allan	Laranjeiras	-22.940860	-43.192000	casa/apartamento	632.648855	25.0	3	2023-10-31	1.45	17	3
1067	1010905172145107938	Home in Rio de Janeiro · New · 3 quartos · 6 camas · 2 banheiros	513697681	Evelyn	Jardim Carioca	-22.806724	-43.186281	casa/apartamento	158.615385	1.0	1	2023-11-04	0.56	1	1
1068	1009889631384884498	Rental unit in Rio de Janeiro · New · 3 quartos · 4 camas · 3 banheiros	23772370	Umer	Lagoa	-22.977202	-43.196998	casa/apartamento	1567.038911	3.0	1	2023-11-21	0.83	1	1
1069	1016576332553624804	Rental unit in Rio de Janeiro · New · 1 quarto · 2 camas · 1 banheiro	23217266	Silvia	Barra da Tijuca	-23.005797	-43.319997	casa/apartamento	1350.845188	2.0	1	2023-11-21	0.81	2	1
1070	1020530393519858555	Rental unit in Rio de Janeiro · New · 1 quarto · 1 cama · 1 banheiro	23217266	Silvia	Barra da Tijuca	-23.005797	-43.319997	casa/apartamento	1350.845188	2.0	2	2023-11-15	1.30	2	2
1071	1022389363072197291	Rental unit in Rio de Janeiro · New · 2 quartos · 2 camas · 1.5 banheiros	15275005	Jonas	Copacabana	-22.965095	-43.181219	casa/apartamento	1311.726228	2.0	1	2023-11-19	0.77	14	1
1072	1051547687623181239	Rental unit in Rio de Janeiro · New · 1 quarto · 1 cama · 1 banheiro	545055587	Rosangela	Praça da Bandeira	-22.914362	-43.211230	casa/apartamento	676.603448	1.0	2	2023-12-23	2.00	1	2

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample